CREATE TABLE [dbo].[C_MATCHSTAGES]
(
[cup] [numeric] (4, 0) NOT NULL,
[matchDate] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[stage] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[C_MATCHSTAGES] ADD CONSTRAINT [pk_C_MatchStages] PRIMARY KEY CLUSTERED  ([cup], [matchDate]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[C_MATCHSTAGES] ADD CONSTRAINT [fk_C_MatchStages_cup] FOREIGN KEY ([cup]) REFERENCES [dbo].[C_CUPS] ([cup])
GO
